• Application Load Balancing In Google Cloud

    Updated: 2024-05-31 15:18:40
    A load balancer is a tool used to distribute the traffic (client requests) to multiple servers on which the applications are deployed so that the response time of the application can improve by spreading the work across multiple servers. Consider an application that needs to serve images to the clients’ requests concurrently. By design it … The post Application Load Balancing In Google Cloud appeared first on Simple Talk.

  • How to verify the Digital Signature of a Signed jar File

    Updated: 2024-05-31 11:12:24
    Skip to content Home Oracle Menu Toggle Oracle database Oracle Ebusiness Suite Oracle weblogic Oracle Performance Tuning Oracle Hyperion Oracle Cloud Tutorials SQL interview questions Linux PHP and HTML Downloads Main Menu About Us Contact Us Download pdf for Oracle Weblogic Unix General Useful Stuffs Hire me Interview Questions Linux Tutorials New Start Here Oracle Tutorials Menu Toggle Oracle Cloud Tutorials Oracle database administration tutorial Oracle EBS 11i R12 R12.1 R12.2 Oracle Hyperion Oracle Performance Tuning Oracle Weblogic Administration Tutorials PHP and HTML Tutorials Privacy Policy Sql tutorial for Oracle MySQL Home » Oracle » Oracle Ebuisness Suite » How to verify the Digital Signature of a Signed jar File How to verify the Digital Signature of a Signed jar File Leave

  • How to identify and change the keystore password in EBS

    Updated: 2024-05-31 10:18:41
    adkeystore.dat  is the Keystore file that is used to sign jar files on the server. Here in this post, we will find out how to identify the password of the keystore and if you are planning to create a new Keystore and wish to change the password, then how to change those passwords. How to … How to identify and change the keystore password in EBS Read More » The post How to identify and change the keystore password in EBS appeared first on Techgoeasy.

  • Generating Uniform, Normal, or Lognormal Random Numbers in SQL Server

    Updated: 2024-05-31 05:00:00
    Learn how to use T-SQL to work with datasets to determine different distribution values in uniform, normal, or lognormal shapes.

  • Replace SQL Cursors with Set Based Operations Including OUTPUT and MERGE

    Updated: 2024-05-30 05:00:00
    In this article, we look at various ways to avoid cursors by using set-based operations with OUTPUT and MERGE to ensure your SQL code can scale.

  • Upgrading SQL Server databases and changing compatibility levels

    Updated: 2024-05-30 05:00:00
    To take advantage of new features in SQL Server, update the compatibility level after upgrading or migrating a database.

  • Dynamic SQL Server stored procedure execution form in SSMS

    Updated: 2024-05-30 05:00:00
    Execute a stored procedure from SSMS and pass in parameter values using the built-in form that SSMS creates.

  • Modify SQL Server database tables to keep similar columns together

    Updated: 2024-05-30 05:00:00
    Learn how SQL Server handles table changes if you try to insert a column in the middle of the table.

  • Encrypt and safeguard your SQL Server database backups

    Updated: 2024-05-30 05:00:00
    Learn about best practices to safeguard your SQL Server backups to protect your data.

  • Purview and Microsoft Fabric: Better Together

    Updated: 2024-05-29 17:00:12
    Microsoft create Purview, a data governance solution. Since Microsoft Fabric was in preview, there was a promise of a deeper integration between Fabric and this governance solution. This integration is finally available. This governance solution is a complete world by itself. This is only a small summary of what’s available. First access to Purview Purview … The post Purview and Microsoft Fabric: Better Together appeared first on Simple Talk.

  • All In One Database Management and Automation Solution

    Updated: 2024-05-29 05:00:00
    dbWatch Control Center integrates all aspects of database management into one solution and automates routine maintenance tasks.

  • What is Mirroring in Microsoft Fabric?

    Updated: 2024-05-29 05:00:00
    Learn about Mirroring for Microsoft Fabric which provides an easy-to-set-up data replication of a source database in Microsoft Fabric.

  • SQL Convert Examples for Dates, Integers, Strings and more

    Updated: 2024-05-28 05:00:00
    In this article, we look at how to use the SQL CONVERT function to convert between data types such as date, integers, strings, and more.

  • Snake draft sorting in SQL Server, part 4

    Updated: 2024-05-27 19:24:25
    In the previous posts in this series (part 1, part 2, part 3), I described how I have optimized a long-running set of routines by processing databases, tables, and even subsets of tables in parallel. This leads to many separate jobs that all kick off at roughly the same time, but because it is difficult … The post Snake draft sorting in SQL Server, part 4 appeared first on Simple Talk.

  • SQL Server Management Studio 20 New Features and Functionality

    Updated: 2024-05-27 05:00:00
    Learn about some of the new features and functionality of SQL Server Management Studio 20.

  • How to Create Kubernetes Deployments and Services using YAML files and Kubectl

    Updated: 2024-05-24 20:39:33
    This article is about how to create Kubernetes Deployments and Services using YAML files and Kubectl. You will also learn how to containerize and deploy any containerized application to Kubernetes. We will create a basic React.js application, containerize it using Docker, and then deploy it to Kubernetes using the Kubernetes Deployment YAML file. We will … The post How to Create Kubernetes Deployments and Services using YAML files and Kubectl appeared first on Simple Talk.

  • The Evolution of Time Travel in Fabric Data Warehouse

    Updated: 2024-05-24 08:30:00
    The May Microsoft Fabric updates bring new about Time Travel in a Data Warehouse. This is good but surprising because this feature is available for a while. Let’s discover what’s new in Data Warehouse time travel. Time travel is a feature of Delta Tables which allow us to retrieve the data as it was in … The post The Evolution of Time Travel in Fabric Data Warehouse appeared first on Simple Talk.

  • SQL Server TRY CATCH, RAISERROR and THROW for Error Handling

    Updated: 2024-05-24 05:00:00
    Learn about SQL Server error handling using TRY CATCH, RAISERROR, and THROW for stored procedures, triggers, and user-defined functions.

  • PostgreSQL CREATE TABLE Examples

    Updated: 2024-05-23 05:00:00
    Learn how to use the PostgreSQL CREATE TABLE command to create tables and temporary tables along with various options and syntaxes for creating PostgreSQL tables.

  • Workspace Identity and Resource Instance Rules: More than simple features

    Updated: 2024-05-22 17:00:33
    Sometimes, when a new feature is announced, it’s in fact hiding bigger changes on the entire environment. This is exactly what happens with these Workspace Identity and Resource Instance Rules. The announcement: We can create OneLake shortcut to an Azure Storage Account protected by the Storage Account firewall. This seems to be a very specific … The post Workspace Identity and Resource Instance Rules: More than simple features appeared first on Simple Talk.

  • Python Control Flow - if, if else, nested if, for loop, while loop and ternary operators

    Updated: 2024-05-22 05:00:00
    Learn how to write Python code to handle conditional logic such as if, if else, nested if, for loop, while loop, and ternary operators.

  • Different ways to determine free space for SQL Server databases and database files

    Updated: 2024-05-22 05:00:00
    One of the functions of a DBA is to keep an eye on free space within the database and database files. The auto grow feature is great as a last resort, but proactively managing the database files is a better approach. Also, this information can be used to shrink data files as needed if there is a lot of free space in the files. In this tip we take a look at a few ways to find the current free space within a database, so you can better manage your database files.

  • Monitoring SQL Server database transaction log space

    Updated: 2024-05-22 05:00:00
    In this tip we look at how to track the growth and usage of your SQL Server database transaction logs.

  • Setting up Database Mail for SQL Server with SSMS

    Updated: 2024-05-22 05:00:00
    In this tip learn how to setup and configure database mail for SQL Server.

  • Oracle 23c/23ai Database New Features

    Updated: 2024-05-21 08:48:32
    Oracle 23c is the latest Release of the Oracle Database. This is also a Long term release. It is also called Oracle 23ai given the focus on AI in it.Oracle has introduced a lot of new features in it. Here are the Top Features Augmenting a new generation of AI models Asking questions naturally While … Oracle 23c/23ai Database New Features Read More » The post Oracle 23c/23ai Database New Features appeared first on Techgoeasy.

  • Oracle Indexes and types of indexes in oracle with example

    Updated: 2024-05-21 07:47:42
    We will be discussing Oracle indexes, types of indexes in oracle with example, and how to create index in oracle in this post. I will through light on all the options on how to create an index in oracle. I hope you will like this post. I will be looking forward to feedback on this … Oracle Indexes and types of indexes in oracle with example Read More » The post Oracle Indexes and types of indexes in oracle with example appeared first on Techgoeasy.

  • Review SQL Table Attributes in SQL Server Management Studio

    Updated: 2024-05-21 05:00:00
    In this tip, we look at ways to quickly get table attributes such as columns, data types, indexes, constraints, and more when using SQL Server Management Studio (SSMS).

  • The CHECK() Constraint

    Updated: 2024-05-20 18:18:04
    One of the many ways a relational table differs from the file structures used by pre-relational storage systems is that the tables, rows and columns can have constraints on them. This allows you to reduce the types of bad data that can be loaded into your tables. This lets the database do a lot of … The post The CHECK() Constraint appeared first on Simple Talk.

  • GitHub Options to Prevent Saving Passwords in Application Code

    Updated: 2024-05-20 05:00:00
    In this article, we look at various GitHub options to help prevent saving sensitive data like passwords in application code files.

  • Exploring MVCC and InnoDB’s Multi-Versioning Technique

    Updated: 2024-05-20 03:06:14
    In the realm of relational databases, MySQL stands out as one of the most popular choices. Maximizing its performance is crucial, especially in highly concurrent environments where multiple transactions compete for resources. InnoDB, the default storage engine for MySQL, employs a technique known as Multi-Version Concurrency Control (MVCC) to address concurrency needs and enhance performance. … The post Exploring MVCC and InnoDB’s Multi-Versioning Technique appeared first on Simple Talk.

  • Power BI Treemap Chart Step-by-Step Tutorial

    Updated: 2024-05-17 05:00:00
    Learn how to use and format the treemap visual in Power BI in this step-by-step tutorial.

  • How to Sort String Date Values on a Power BI Slicer Visual

    Updated: 2024-05-16 05:00:00
    In this article, we look at how to build a slicer visual in Power BI and how to create a custom sort order for the slicer values.

  • Large Language Models with Azure AI Search and Python for OpenAI RAG

    Updated: 2024-05-15 05:00:00
    Learn how to infuse Azure SQL data with retrieval augment generation (RAG) which allows large language models (LLMs) such as GPT to provide answers to complex questions.

  • Analyzing Unplanned Availability Group Outages and Failovers using AGDiag

    Updated: 2024-05-14 05:00:00
    Learn how to use the AGDiag tool to troubleshoot and analyze SQL Server Always On Availability Group issues.

  • Microsoft Fabric Monitoring with Metrics App and Data Activator

    Updated: 2024-05-13 05:00:00
    In this article, learn about the Metrics App and Data Activator for Microsoft Fabric for monitoring and taking necessary administrative action to control Fabric capacity.

  • SQL Bulk Insert Command Examples

    Updated: 2024-05-10 05:00:00
    Learn about the SQL Server BULK INSERT command and how to use it to import text data in a SQL Server database table.

  • Build a Secure SQL Server REST API in Minutes

    Updated: 2024-05-10 05:00:00
    Learn how to build a secure SQL Server REST API in minutes with DreamFactory which is middleware that connects all of your applications across the enterprise in a secure manner.

  • SELECT TOP 10 SQL Examples

    Updated: 2024-05-09 05:00:00
    In this article, we look at various ways to use SQL SELECT TOP to return a certain number or percentage of rows when selecting data.

  • Data Quality Management Issues in Time Series Analysis Resolved with Python

    Updated: 2024-05-08 05:00:00
    In this tutorial, we delve into critical aspects of data quality management when working with time-series data and we will use Python to demonstrate.

  • Mastering SQL Server Local and Global Temporary Tables

    Updated: 2024-05-07 05:00:00
    In this article, we walk through the syntax for creating SQL Server local and global temporary tables and some use cases for when and how to use them.

  • how to check trigger status in oracle

    Updated: 2024-05-06 09:20:33
    Triggers are an important construct in Oracle. These are the codes that are fired when a row is updated, inserted, or deleted in the Oracle table. Let’s find out how to check trigger status in Oracle, how to check trigger definition in Oracle, How to find all Trigger in the table, and many more How … how to check trigger status in oracle Read More » The post how to check trigger status in oracle appeared first on Techgoeasy.

  • Azure Synapse Analytics and Power BI Integration

    Updated: 2024-05-06 05:00:00
    In this article, learn how to integrate Power BI reports with data from Azure Synapse Analytics in this step-by-step tutorial.

Current Feed Items | Previous Months Items

Apr 2024 | Mar 2024 | Feb 2024 | Jan 2024 | Dec 2023 | Nov 2023